package com.hy.dao;

import com.hy.bean.Deptfunds;

import java.math.BigDecimal;
import java.sql.Connection;
import java.util.List;
import java.util.Map;

/**
* @author 冯俊杰
* @description 针对表【DEPTFUNDS】的数据库操作Mapper
* @createDate 2024-05-08 08:55:05
* @Entity com.hy.bean.Deptfunds
*/
public interface DeptfundsDao {
    List<Map<String,Object>> selectAll(String deptName) throws Exception;

    //查看某个部门经费使用情况
    List<Map<String,Object>> selectDeptAll(Integer deptId) throws Exception;
    //减
    Boolean updateDeptBalanceMinus(Connection conn, BigDecimal deptId, BigDecimal balance) throws Exception;
    //加
    Boolean updateDeptBalanceAdd(int deptId,Double balance) throws Exception;

    Boolean deleteById(int deptId) throws Exception;
}




